const Sequelize = require('sequelize');
module.exports = function(sequelize, DataTypes) {
  return sequelize.define('zjb_companyinfo', {
    BelongXiaQuCode: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    OperateUserName: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    OperateDate: {
      type: DataTypes.DATE,
      allowNull: true
    },
    Row_ID: {
      type: DataTypes.INTEGER,
      allowNull: true
    },
    YearFlag: {
      type: DataTypes.STRING(4),
      allowNull: true
    },
    RowGuid: {
      type: DataTypes.STRING(50),
      allowNull: false
    },
    CorpName: {
      type: DataTypes.TEXT,
      allowNull: true
    },
    CorpCode: {
      type: DataTypes.STRING(50),
      allowNull: false
    },
    areacode: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    Address: {
      type: DataTypes.TEXT,
      allowNull: true
    },
    PostalCode: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    LicenseNum: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    LegalMan: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    IDCardTypeNum: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    LegalManIDCard: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    LegalManDuty: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    LegaManProTitle: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    EconomicNum: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    RegPrin: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    FactRegPrin: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    PrincipalUnitNum: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    CorpBirthDate: {
      type: DataTypes.DATE,
      allowNull: true
    },
    OfficePhone: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    Fax: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    LinkMan: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    LinkTel: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    LinkPhone: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    EMail: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    Url: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    Description: {
      type: DataTypes.TEXT,
      allowNull: true
    },
    isjinan: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    checktime: {
      type: DataTypes.DATE,
      allowNull: true
    },
    systemurl: {
      type: DataTypes.STRING(255),
      allowNull: true
    },
    systemurll: {
      type: DataTypes.TEXT,
      allowNull: true
    }
  }, {
    sequelize,
    tableName: 'zjb_companyinfo',
    timestamps: false
  });
};
